How to merge your addresses in Canva
One spreadsheet, one print job, and not a single hand cramp. Here’s the whole process, including the column names that won’t fight you.
Traci · 6 min readYou could open the template, type a name, print it, and then do that 199 more times. Or you could let Bulk Create do every bit of the typing while you go do literally anything else! Twenty minutes the first time through, about five every time after that.
Two things before we start. Bulk Create needs Canva Pro, and it only runs on an actual computer (sorry, phone people). On the free plan? Skip on down to the bottom...I didn’t forget about you.
First, the spreadsheet (don’t panic)
One row per envelope. Your top row holds the column headers, and those exact headers turn into the field names you’ll see inside Canva, so keep them short and simple.
Here’s the part everybody gets wrong the first time: every single line of the address needs its own column. Squash the whole address into one cell and Canva hands it right back to you as one long unbroken line of text. Not cute!
Leave the extra cells actually empty. One stray space in there becomes a mystery blank line in the middle of the address...and only on some of them, which you absolutely will not notice until all 200 are printed. Save it as a CSV, or keep it in Google Sheets and share the link.
Bulk Create will take 300 rows and 150 columns at a time, so a 200 name list is no problem at all. Longer than that? Split it in half and run it twice.
Now introduce Canva to your columns
Open your template in Canva on a computer and click Apps in the left sidebar. Search for Bulk Create.
Upload your CSV, paste your Sheets link, or type it all in by hand. Delete Canva’s sample rows first or poor Jane Doe is getting an envelope!
Click the first line of the address on the envelope, open More (the three little dots), choose Connect data, and pick the column that goes with it.
Do that for each line. Auto-match fields will try to guess them all at once and it’s usually right...but check its work anyway.
Hit Continue, then scroll all the way through the preview before you generate a thing.
Spend two minutes in that preview screen. Two minutes there will save you from reprinting 200 envelopes!
What you’re looking for is any text that has outgrown its box. Long street names and beautifully hyphenated last names are the usual suspects. Fix those in the spreadsheet, never on the design...otherwise your fix helps exactly one envelope.
Look good? Choose Create designs.
Now the fun part
Download as PDF Print and you’ve got one page per envelope, in whatever order your spreadsheet had them.
Before that whole stack goes anywhere near your printer, print page one on plain paper and hold it up against a real envelope in front of a window. Trim the paper down to the size of your envelope first, so you’re comparing the same thing. Ten seconds! And it catches a wrong paper size before it costs you a thing. Then load your envelopes according to your printer’s settings, and go.
Print ten. Look at them. Then print the rest. Printers only ever jam the second you walk away to go do something else...every single time.
I have noticed that my printer does much better when I print in smaller batches instead of loading 100 envelopes and expecting it to pull in each one the exact same way. I do about 10-15 at a time. It takes a couple more minutes this way but it saves me envelopes and my sanity.
Not on Canva Pro? I’ve got you.
Merge & Print does the whole merge right here on my site. Paste your list in, see every address on the design before you print, and send the finished sheet to your printer. No Canva account, no Pro plan, nothing to install.
{{ mergeLine }} Try Merge & Print